package cn.bdqn.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import cn.bdqn.entity.Users;

public interface UsersMapper {
	Integer queryUsersCount();
	Users queryLogin(Users users);
	Users queryUserName(@Param("username")String username);
	Users queryUserEmail(@Param("email")String email);
	Users queryUserByuserid(@Param("userid")Integer userid);
	Integer updateUsers(Users users);
	List<Users> queryAllUsers(@Param("username")String username,
			@Param("start")Integer start,
			@Param("pageSize")Integer pageSize,
			@Param("floorid")Integer floorid,
			@Param("layerid")Integer layerid,
			@Param("roomid")Integer roomid);
	Integer queryCountUsers(@Param("floorid")Integer floorid,
			@Param("layerid")Integer layerid,
			@Param("roomid")Integer roomid,@Param("username")String username);
	Integer saveusers(Users users);
	//查询一个房间的人数
	Integer querypersonnum(@Param("floorid")Integer floorid,@Param("layerid")Integer layerid,@Param("roomid")Integer roomid);
	//移出宿舍
	Integer deleteUsers(@Param("userid")Integer userid);
}
